package com.gxa.employment.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.gxa.employment.entity.dto.PageBean;
import com.gxa.employment.entity.pojo.ClazzStudent;
import com.gxa.employment.entity.pojo.Employment;
import com.gxa.employment.entity.pojo.Student;
import com.gxa.employment.entity.vo.ManagerRateVo;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;


/**
 * <p>
 * 学生就业信息表 Mapper 接口
 * </p>
 *
 * @author author
 * @since 2025-03-25
 */
@Mapper
public interface EmploymentMapper extends BaseMapper<Employment> {

    //该项目经理的就业率
//    @Select("SELECT clazz_manager clazzManager,AVG(employment_rate) avgEmploymentRate FROM v_clazz_student GROUP BY clazz_manager ORDER BY avgEmploymentRate DESC")
    List<ManagerRateVo> selectManagerRate();
//    查询项目经理班级信息
    List<ClazzStudent> selectManagerClazzInfo(PageBean pageBean);
    //    查询项目经理班级信息  总数
   Integer selectManagerClazzInfoTotal(PageBean pageBean);

    //批量插入学生就业信息表
    Integer insertAll(List<Employment> list);
}
